package com.kcyu.sfherp.entity.utilEntity;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.format.DateTimeFormat;
import com.alibaba.excel.annotation.write.style.ContentStyle;
import com.alibaba.excel.enums.poi.HorizontalAlignmentEnum;
import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.Data;

import java.sql.Timestamp;

@Data
public class ExcelSeriesDetail {

    @ExcelProperty("商品编号")
    private String spbh;

    @ExcelProperty("商品名称")
    private String spname;

    @ExcelProperty("客户编号")
    private String khbh;

    @ExcelProperty("客户名称")
    private String khname;

    @ExcelProperty("件数")
    private Float js;

    @ExcelProperty("件单位")
    private String dw;

    @ExcelProperty("散数")
    private Float xs;

    @ExcelProperty("散单位")
    private String dw2;

    @JsonFormat(pattern="yyyy-MM-dd HH:mm:ss",timezone="GMT+8")
    @DateTimeFormat("yyyy-MM-dd HH:mm:ss")
    @ExcelProperty("日期")
    @ContentStyle(horizontalAlignment = HorizontalAlignmentEnum.RIGHT)
    private Timestamp rq;


}
